Metadata (Global transformations only)
The Metadata tab contains the following variables that you can use in an expression. Variables with MODIFIED in their name can be used to specify metadata that has been replaced or modified using a global transformation (such as Convert data type) whereas variables names without MODIFIED can be used to specify the original metadata as it is defined in the source database.
- AR_M_MODIFIED_SCHEMA - The modified source schema name.
- AR_M_MODIFIED_TABLE_NAME - The modified source table name.
- AR_M_MODIFIED_COLUMN_NAME - The modified column name in the source table.
- AR_M_MODIFIED_COLUMN_SUBTYPE_NAME - The modified data type subtype of a column in the source table.
- AR_M_MODIFIED_DATATYPE_NAME - The modified data type of a column in the source table.
- AR_M_MODIFIED_DATATYPE_LENGTH - The modified data type length of a column in the source table.
- AR_M_MODIFIED_DATATYPE_PRECISION - The modified data type precision of a column in the source table.
- AR_M_MODIFIED_DATATYPE_SCALE - The modified data type scale of a column in the source table.
- AR_M_SOURCE_SCHEMA - The name of the source schema.
- AR_M_SOURCE_TABLE_NAME - The name of the source table.
- AR_M_SOURCE_COLUMN_NAME - The name of a column in the source table.
- AR_M_SOURCE_DATATYPE_NAME - The data type of a column in the source table.
- AR_M_SOURCE_DATATYPE_LENGTH - The data type length of a column in the source table.
- AR_M_SOURCE_DATATYPE_PRECISION - The data type precision of a column in the source table.
- AR_M_SOURCE_DATATYPE_SCALE - The data type scale of a column in the source table.
Example: Using metadata variables in the Rename Column transformation
To rename all columns named "product" to "source_schema.table_name", enter "product" in the Column name is like field (in the Transformation scope screen) and then enter the following expression in the Rename column to field (in the Transformation action screen):
$AR_M_SOURCE_SCHEMA ||"."|| $AR_M_SOURCE_TABLE_NAME